Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# STANDBY_ARCHIVE_DEST

Property | Description
--- | ---
Parameter type | String
Syntax | `STANDBY_ARCHIVE_DEST =` `filespec`
Default value | Operating system-specific
Modifiable | `ALTER SYSTEM`
Range of values | A valid path or device name other than `RAW`

`STANDBY_ARCHIVE_DEST` is relevant only for a standby database in managed recovery mode. It specifies the location of archive logs arriving from a primary database. Oracle uses `STANDBY_ARCHIVE_DEST` and `LOG_ARCHIVE_FORMAT` to fabricate the fully qualified standby log filenames and stores the filenames in the standby control file.

You can see the value of this parameter by querying the `V$ARCHIVE_DEST` data dictionary view.

See Also: Oracle Data Guard Concepts and Administration for more information on setting this parameter and on managed recovery mode in general "LOG_ARCHIVE_DEST" and "V$ARCHIVE_DEST"